SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037097 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037097 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813683,375832,552825,342611,698780,209841,240458,195043,715012,866031,189000,210737,1000771,967051,224162,134973,848914,215435,6941,652557,35530,996727,347181,998981,295002,715666,823709,317486,356114,10815,868039,735095,170830,502745,319169,362661,132806,987301,299207,892996,956223,548604,1031144,44634,395086,393099,395113,1033421,686431,125143,1534,316408,302497,796879,1015671,505857,1036001,319307,939912,99045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]