SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398346 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398346 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323824,122496,437867,111238,443468,1007404,854789,123321,931581,433498,106212,901205,199912,782550,393583,105018,737224,582369,289403,710769,176955,612011,418403,423249,626561,72550,726989,1027257,709646,46635,738453,26824,670060,898879,753537,959372,999329,592492,393996,153044,524234,723785,537257,607021,662691,309251,44607,744228,807785,855777,101502,1003840,364470,1035842,900098,1008592,332605,234796,979970,76895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001292s ]