SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194840 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194840 [ RunTime:0.003145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214378,1027033,195613,1037409,179103,872589,172690,921352,185929,1048144,19579,95200,400745,589662,314668,141037,59904,859221,613578,647007,340878,745515,393218,879795,812520,489213,824205,752786,60825,821033,193752,528278,433,983416,433617,91932,880565,662195,33912,14141,295934,940887,636283,454722,271874,231886,75425,113724,331143,770701,491893,354174,645958,97872,910884,1033060,446756,176403,652708,469982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]