SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413475 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413475 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72838,944172,396598,63928,636254,845637,941000,141604,933840,527198,287828,651853,184486,556754,672933,214043,1028635,543291,438724,461656,963661,349025,417000,956471,55947,952487,445507,804282,1044173,113610,718417,601389,327932,1044699,189631,404185,130234,134692,43518,320900,656154,400047,235199,110409,42757,1038984,428160,84619,106796,940596,389607,526215,592234,699859,461545,853809,869615,101278,371305,312842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]