SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292708 LIMIT 1 [ RunTime:0.007335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292708 [ RunTime:0.003234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160534,218993,112956,250550,519434,729892,378175,90806,35851,612940,196226,553754,142346,776220,64019,682850,557541,465087,353810,800791,128089,250582,483658,149320,59389,417847,1003124,846029,731616,1039569,197817,1018063,546250,1048429,151430,493382,145308,221311,938769,554564,943398,468800,164509,1017616,720893,837558,220741,756425,173344,883149,165602,174775,183743,309244,1002412,814702,439698,878982,302646,107410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008310s ]