SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380043 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380043 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510968,560895,108672,729168,641989,340326,394047,1045836,179815,701750,907355,1007782,95139,1048678,998775,792380,143929,800574,104795,303217,807979,903448,291303,918118,439178,472314,140685,200009,294794,986741,522403,650982,646200,779490,676750,672914,118154,872354,57591,664929,991894,736650,772213,646671,630784,925331,130941,999672,402698,621342,898775,488613,49219,417099,990603,721862,306064,411776,477819,341015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]