SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 156099 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 156099 [ RunTime:0.004264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978506,427112,500875,186473,314206,613775,530766,834903,955283,742016,670807,482426,431221,921682,853048,857423,656140,96218,257,532215,444687,104986,494004,671796,181856,56860,723230,62825,116509,196367,506476,363289,791118,898691,71363,115900,685340,943504,703142,426148,394858,365182,196604,766021,735487,30490,107961,465688,829324,247140,21318,595254,231432,146254,122935,823547,976724,346904,478856,476059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 156099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 156099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]