SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503770 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503770 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807012,176137,232820,974875,660793,420705,1016152,788271,920738,406942,596132,525502,410112,1043760,910782,745827,899865,820572,93844,839901,10483,920732,482920,972250,272510,814030,458588,129561,617802,172561,748588,636419,631749,579022,145384,614188,89600,725610,280132,798188,621391,642495,547490,7316,750815,810358,305418,382577,1038804,897733,226192,681112,414857,380843,644643,321348,164356,584078,659348,497856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]