SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410141 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410141 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219541,531905,40979,414463,472716,258952,1032987,531302,1003220,532376,606466,962671,662516,27168,407701,274019,372341,717738,730304,787243,582369,2938,594155,121164,478666,596948,287337,82845,741865,587297,29240,496904,206095,478216,958679,799562,855664,157385,320214,469696,765706,849968,307959,933537,662992,949149,789532,586684,887762,6596,205473,220840,338750,306329,225609,311039,330,237836,186673,640077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003835s ]