SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 767810 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 767810 [ RunTime:0.005120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869536,600281,389283,30038,682577,991220,922215,458005,337173,965412,493967,130667,812499,273781,55232,1015978,988757,223027,180423,490601,980497,256797,507992,476149,390803,989156,174657,420770,328200,316575,351070,430670,826656,392933,691256,889489,526914,982522,107151,436045,891764,122159,534171,476335,869885,571178,362230,790600,15318,55997,144798,617934,520984,640473,1020896,268035,1045013,853271,173502,407847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 767810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 767810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]