SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108141 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108141 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611008,40506,1022067,490156,791329,387459,210588,808694,560055,68723,661861,651851,305301,1031132,297080,630272,164404,565735,199877,199340,395248,299525,48332,1020694,82712,437952,997615,861053,399994,466327,936799,172928,688742,368806,75190,212358,244925,572999,106094,939273,469233,383795,78021,225355,954969,905133,447550,524503,422358,238328,530374,14064,674023,685741,403209,900217,633217,975516,771966,958232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]