SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596332 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596332 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192831,349479,64297,91052,606030,1007100,778229,471994,48118,971132,460778,362301,864764,635613,138631,135495,36425,192524,321674,143334,347093,459518,86277,326872,809804,693650,780317,940689,914263,680171,222291,899110,787147,638347,279447,371087,265250,708406,251904,378688,574895,809098,154885,239283,601133,602428,277063,822725,922800,900134,66596,250647,748686,999262,155670,111096,415194,924518,401749,459530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]