SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286611 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286611 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035371,1006384,117882,448636,304399,33610,690027,113202,1003920,235821,886258,134522,582013,788102,497066,815939,468351,121575,17606,189257,755503,825326,330824,842238,176276,229178,967385,63643,219325,477391,27287,70842,778254,974152,889952,269961,553733,977009,38675,959388,235998,684129,759168,996191,606605,370760,773480,228745,32729,77625,325798,1018243,1038397,530785,474166,864488,206017,366326,105564,187229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]