SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534103 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534103 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2572,1031860,404730,810864,987761,203191,677849,148789,940244,24795,724786,938901,930131,262451,28049,854746,52839,384603,9222,189717,515172,681167,327266,44093,56244,203460,123247,475198,100698,1030974,236415,896119,1036568,216969,794050,428430,808008,252981,888914,120925,379652,817362,674954,765833,724983,510799,924087,746787,751532,793463,367329,442629,381191,75239,385265,287934,121444,775616,919225,280340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]