SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201284 LIMIT 1 [ RunTime:0.002596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201284 [ RunTime:0.003935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640211,480835,604426,114964,553810,397233,972601,298060,999849,493091,510784,685516,201732,264555,415088,538684,518226,127658,334905,583534,644703,598939,221996,898058,84072,561242,968719,841936,543089,263855,138790,1022281,75398,192210,739753,271121,462397,126376,817258,295884,886268,872345,433819,758725,522215,205395,886547,854279,968076,735302,158415,167260,212651,44575,270955,4411,1022774,836778,568184,475663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]