SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439822 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439822 [ RunTime:0.006326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017245,839494,473950,580341,418227,275946,622872,669982,765422,181257,548616,864800,190048,883864,786851,12090,446576,794434,287047,1041963,799649,415766,969563,58063,995078,152637,710744,471530,755755,819537,3370,551116,291260,923097,705322,1033293,635389,936585,713999,576004,315365,452744,18975,781343,214288,102800,562433,431240,699429,952523,21657,932832,600368,1020237,344289,573674,806181,275974,663599,761509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003950s ]