SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4264 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4264 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837412,521273,215243,310488,580318,809669,786796,806429,609390,877762,807254,219893,793940,66213,547001,254129,848002,540871,227285,91001,441073,411392,509002,681933,823411,569422,102475,288732,139392,472218,267663,17871,148236,857548,220807,241564,822623,5858,1031996,224185,836848,988402,251829,1042292,67235,448705,851479,811273,940089,1030924,178918,920998,81346,69809,843447,429324,567215,71949,646822,538724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]