SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330019 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330019 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642781,19068,842445,536803,201877,1006025,503731,860928,184348,161282,185340,657118,809090,466882,950572,401995,809702,996047,515572,318089,790275,783440,965822,680783,308277,51832,372922,688983,8370,177042,564069,288002,133727,191833,399475,538985,865507,558013,795345,500129,329927,646625,88625,319979,719459,728348,690502,809765,322939,86341,406549,581081,694887,676186,353694,223548,953998,210376,255392,540459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]