SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480106 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480106 [ RunTime:0.006390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002598,42630,439802,652677,852710,96805,171808,800445,798875,965907,839038,836580,399671,55676,131014,917143,164986,581807,197087,130895,968547,805565,29841,824837,812483,20228,450340,381176,652749,933999,750571,905038,763286,863686,58593,35878,837911,354581,677339,863615,317404,794927,39292,631035,370911,260686,159005,392095,90630,386927,1030190,869167,1032652,28471,329040,421836,42787,535504,731848,387100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001727s ]