SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412536 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412536 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481319,821088,103997,728064,200950,844502,962562,57957,543634,248086,974468,999744,231619,919913,111290,6243,272031,385879,708548,442039,476826,1036139,780093,418595,429160,748713,724704,332907,438576,621742,555023,218520,808170,415753,617748,568101,277084,961446,294296,170805,895853,551983,757875,13843,897471,424784,549892,810872,595837,430718,149749,487209,622937,505234,628143,396534,105899,853392,858232,162333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002293s ]