SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502814 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502814 [ RunTime:0.003144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569082,615588,545535,864945,415490,773166,344949,759100,62929,74143,874694,457630,314059,482271,786475,263305,773043,867595,574211,940503,626972,369115,705809,388051,735866,61633,1030450,369246,480560,417062,955398,833983,898103,863543,476013,870187,279219,908990,1012656,737713,494978,83758,624733,509459,289701,516518,142356,218204,965158,1042471,402024,47403,1001785,989998,49846,636928,629712,787930,583685,298032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]