SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012836 LIMIT 1 [ RunTime:0.000834s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012836 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38024,461550,766580,70472,680035,954120,141307,127422,653351,242803,191626,80993,42480,179043,505174,547363,283285,1034227,495238,584146,622534,104304,795817,512856,185213,489959,972425,990223,122911,468075,133227,643709,193354,855131,1014239,1040214,858835,919038,689135,805764,121061,107530,173559,972869,345810,945551,731244,401227,190965,569715,228650,258671,728870,258541,97667,86345,469644,362491,37208,965510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]