SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402741 LIMIT 1 [ RunTime:0.001861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402741 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822901,286646,948289,396950,263564,829310,751638,248409,431037,21756,414475,7592,123329,176718,954450,636343,490724,431372,363427,87142,679512,867933,4992,49468,375211,732827,290498,691724,384567,157739,565444,317233,950121,859526,595541,834614,587321,56459,101990,323627,862247,753115,42430,346338,583055,821083,288129,559955,908010,139417,214567,890895,328890,409974,284938,923445,157961,263454,356037,65801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]