SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320082 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320082 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379971,465653,664554,254173,407849,950786,930832,177956,755038,754205,777170,655007,445603,761828,256677,114295,634545,164688,902718,105811,152102,965321,652457,409530,537801,184285,892189,14453,840256,808311,904039,277017,766782,301065,327707,705436,662894,207350,332261,195072,832446,279243,74532,354997,328611,534716,415843,216636,631682,36430,233180,984544,201088,211811,583371,636623,808260,378564,680802,599392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]