SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043762 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043762 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436570,841466,14381,376118,691365,11299,605030,975087,679702,747918,547192,125680,691564,794952,678447,453330,636714,394218,276213,875599,671273,9017,552511,903805,571977,241578,297050,67632,115885,414319,780063,1046128,852602,256035,231139,247306,834014,13919,242089,269402,747847,348471,526757,764668,399234,19690,67372,290912,209353,351420,479950,789412,842171,709920,696222,58493,817503,484336,865799,812973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]