SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104181 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104181 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723890,338060,217032,1027517,520140,790201,451984,672896,762055,997282,735252,524202,1031514,738379,688407,701656,113062,958814,465470,521908,1012978,594150,324819,901115,179034,676153,417116,351192,450845,688745,338558,626700,196847,470955,219269,383801,604867,422836,828078,251718,499289,884972,671874,825575,544778,90654,986996,631145,662796,1043386,868163,294065,444860,667972,904147,305812,410062,291469,149210,153623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002568s ]