SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293120 LIMIT 1 [ RunTime:0.000911s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293120 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30140,532918,281978,405990,1011307,601350,410648,1013896,681115,201475,923175,385045,1005459,687595,687108,675283,812559,47172,807732,373987,854296,736877,52301,154252,451664,921560,317683,483729,793276,40242,625121,174614,365497,403384,420478,339163,842458,91724,438273,486048,239366,436635,15360,484182,649624,405971,272697,531174,331730,15874,485660,865464,529290,765329,281251,2181,352452,500137,334424,354211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]