SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019652 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019652 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254230,743043,294403,279844,554866,863460,785192,50430,587036,478750,50497,1016113,125911,492646,315001,98734,1025697,379398,1011219,557401,915479,752879,427359,36426,38489,314591,561465,489796,382381,70988,673246,305606,997224,747237,724460,301985,798024,911426,313348,714746,93042,841884,697549,165931,737281,98720,820061,50076,156651,785859,828931,567373,600316,610225,840340,165520,540437,71090,385276,925253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]