SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519175 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519175 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458031,534171,323610,659634,195755,480113,320070,417239,588792,255481,995179,497184,39229,320832,364364,385311,875509,938176,763725,491577,604077,4928,341084,334903,323772,923533,373533,1024068,1032536,577931,136579,959238,276438,858715,952623,872422,328351,251347,1028154,737312,127438,239465,313750,531561,178237,88717,805892,529818,423591,408243,994396,972934,320642,480959,338284,362691,404114,581333,243790,887821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]