SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686263 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686263 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287883,672888,500206,835085,485795,288223,443040,694342,70221,992800,557261,254584,322628,957900,798366,372860,66930,249062,894971,560452,507615,1033849,1033361,718524,710668,855891,173050,465727,360203,361835,271448,489040,642704,349452,997693,544970,657126,1046087,157113,76781,308316,844987,310412,866950,601012,158890,988860,591690,380870,154461,962773,337285,623519,858216,5395,869149,93299,873886,2310,940328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]