SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590943 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590943 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507047,9697,494813,129206,556698,1022215,854094,174942,721753,279101,782602,1022385,74939,967544,80867,353165,1047040,1001705,728298,480262,50660,826038,431558,352794,343851,1042715,205170,343307,862301,311809,893231,908865,498190,738725,175345,447390,387350,71213,838182,625967,143948,74383,994733,765654,109354,454791,616463,264578,982710,218187,480590,473020,706838,479712,997643,629027,168269,797054,712028,909882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]