SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031743 LIMIT 1 [ RunTime:0.001125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031743 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108692,187945,1030548,619004,72970,322670,735020,440930,47615,39353,374131,252845,219823,561483,775957,202269,333667,252799,1023614,713754,260861,588653,73630,412113,415455,449185,846845,129375,126327,694540,938761,587775,950920,958934,424868,244407,351629,769810,79504,1020694,891178,376927,922801,5565,297590,997814,780806,217211,765401,785751,242383,1038493,286565,394230,635554,950752,607572,453870,189258,579690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]