SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541134 LIMIT 1 [ RunTime:0.000773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541134 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443157,300587,853741,401039,106429,793462,439288,5977,1019601,986132,767763,1017048,205291,274781,146282,50568,263208,315774,818555,665843,181973,82204,366635,804844,717153,949740,348317,946835,905950,686533,971715,571130,86724,698311,772976,715754,150398,122905,596774,818441,511061,638830,1027966,789834,183670,1028483,821983,528595,24818,147443,954434,287575,772809,484647,716227,476160,126345,468154,1032857,781064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]