SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310943 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310943 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379174,498180,135067,511916,343786,30402,889999,628573,235231,12456,468399,73704,564890,155734,658465,562261,105215,679892,613952,300137,378495,67399,175348,204435,808217,649394,948269,397050,528809,225547,653297,846616,440354,827894,555016,606138,382072,80011,1042192,181365,800884,733260,796376,267124,563092,893823,281311,662075,828096,166537,851242,156216,616488,586104,215436,358984,655848,877240,812823,80703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000977s ]