SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506471 LIMIT 1 [ RunTime:0.001760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506471 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26749,312484,656074,761425,654093,794513,575293,412027,664128,788434,763392,202012,140333,874874,719981,330239,160969,75748,718135,866096,707976,939101,45923,524026,925947,196171,334096,656652,279278,661148,393731,905758,400979,444345,1029485,631508,697713,9448,840791,527816,609754,982748,797143,460047,975176,156920,1019200,879904,920238,837534,535444,604220,1001373,479118,527451,885671,476781,737870,496644,305657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003042s ]