SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596815 LIMIT 1 [ RunTime:0.001343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596815 [ RunTime:0.003147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630205,492819,300029,672937,112033,638986,233934,724912,797154,325239,456687,953806,930197,840100,592779,425612,911588,919877,440267,427536,921013,117520,195484,819352,60681,12783,232354,855029,377998,836280,328167,233720,528455,986325,700681,111280,797262,391021,727315,548714,241680,949543,586089,1011027,719864,420260,140530,927979,790033,793771,617446,157186,481981,480883,465470,506584,41292,794756,196643,673724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002081s ]