SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191043 LIMIT 1 [ RunTime:0.010252s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191043 [ RunTime:0.011609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640744,775397,954331,825599,898637,46456,997016,296484,341281,334917,840757,29881,57030,723865,639090,309065,895607,41282,503594,108675,435445,377930,984373,704281,1031783,663971,753502,856573,198591,942385,936805,522820,107138,853887,211891,806701,250764,556260,794916,307741,586316,292140,936549,258501,1019240,639901,1016981,597330,84776,586174,533966,613525,852825,696731,537572,287421,257078,640659,957613,703714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.011049s ]