SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040852 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040852 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284286,696278,206563,767483,190435,641140,110178,883502,784083,78483,887504,562783,480960,208334,815341,894847,1021412,580562,287468,205114,191964,1009729,1010014,83022,484232,429461,756870,870938,546197,19562,851130,848608,659358,1033432,114555,36243,1048478,502429,515286,542898,719042,662535,185081,229003,1030563,984139,323408,64652,149028,787840,499673,367104,285273,723524,407731,656803,718399,933013,1025260,327593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]