SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96394 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96394 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774036,203301,394464,86865,934034,809680,141612,1034467,414569,29934,419754,438969,909826,149084,340352,490626,507144,856103,807713,895385,368562,1000667,313788,524558,440651,1009694,201794,103269,316017,592174,142804,791819,110496,270563,597840,516743,519007,976309,557859,270578,66879,538644,569536,148853,136873,251437,269970,2713,51826,467922,648431,409912,320586,6413,979010,440490,661023,954975,43075,1000964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]