SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501310 LIMIT 1 [ RunTime:0.002335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501310 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857288,331534,109678,331420,504296,919830,517503,83572,539273,341331,537869,659781,347406,280606,106592,526941,887580,668764,403946,788214,895737,296213,945591,591570,185455,1035171,258754,846192,187836,970766,509223,1004517,345489,373993,217330,901932,586100,453329,570170,118948,385615,637639,25470,405498,998651,955532,779939,989685,369616,898366,548724,454066,565591,302429,825661,584721,351406,617733,26250,404634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]