SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045799 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045799 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304348,499954,416848,456156,135967,69981,650948,391550,79291,560380,25720,806612,22413,263777,320250,612323,576154,495477,548298,68150,56113,352723,826743,926845,801740,40212,134992,741496,599237,816084,283298,17919,235540,621515,256777,403212,1019240,105959,152355,265996,846573,576611,721162,606634,325167,828778,160987,851735,498834,128905,56514,555707,671487,946613,385827,956585,131275,269751,483370,456502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]