SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010074 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010074 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407241,1035500,813833,360123,347750,641454,11973,600597,42224,1023865,182165,124196,870914,924754,890684,209039,746305,702343,319916,913788,678537,604141,152865,289489,591053,279303,47847,653008,262676,654888,1010840,997347,171054,710742,926769,401312,182192,292240,384067,901285,39749,853726,61934,238567,743695,541136,530024,422587,796232,25630,1034888,718946,564688,734049,919877,242937,492930,744232,961968,544257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]