SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418093 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418093 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991697,242131,168012,657616,927164,726728,877510,251507,462299,613113,168722,50170,1033949,236309,861581,119155,342708,31752,486946,986095,451044,877373,191610,179000,2646,637228,887489,960444,314352,1036344,171387,283300,958595,52837,262138,156061,389131,936430,12238,877528,234945,503078,263701,128018,519000,394558,229327,552612,1045046,315067,110996,341005,609483,463830,213618,873999,136655,265982,138376,711220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]