SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460947 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460947 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492837,617793,516623,607738,656280,261997,627868,870394,966909,456649,274286,895892,30821,318804,231707,394978,395210,273391,388175,1036142,979941,266740,919300,9704,737852,498101,984832,1037230,866194,768897,897484,418858,84012,873894,377233,170179,121022,982608,625179,803230,454356,192258,259937,345519,756954,572671,925800,869019,846690,513147,752776,166516,312000,939256,742054,412184,889505,385918,332182,182964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]