SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817190 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817190 [ RunTime:0.002881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889713,728539,792473,825794,467929,642013,976489,1030808,537698,827152,212202,451466,158557,337617,164356,149885,309084,892294,931397,639533,693873,312187,520438,208128,613563,125581,833595,504663,167920,656539,928671,484517,912199,715067,466331,1042112,46875,930392,868779,460865,138999,786389,652133,300909,1000911,692056,1024513,932040,104770,781719,639372,752532,201682,735760,467903,306016,772885,388111,89790,696795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]