SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244813 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244813 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873779,802285,661776,1043452,466714,744102,885215,329118,614419,244611,706517,833623,944218,434717,746835,40251,873769,104944,776640,273328,61827,768505,714500,415946,961793,69765,141546,831949,949483,137328,46022,4307,1016766,253639,471662,689742,954724,247810,81441,574567,122508,86084,725353,600085,24949,658067,33469,224978,978154,904235,753087,732894,135404,711617,713475,18187,42238,847806,195795,320596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]