SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601004 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601004 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470057,404531,969169,497890,642211,260505,486588,949400,1038453,935825,132147,685515,103086,561814,988142,53161,609783,12872,609788,443710,826383,494928,203442,499459,799174,368133,455269,19346,543603,337723,308902,485863,867006,745368,522624,536756,363528,831060,58020,1042630,1017815,255645,774901,81242,203608,983780,699091,491490,113083,526791,229191,459328,884410,75170,429110,983250,758722,202104,652741,340949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001967s ]