SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340740 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340740 [ RunTime:0.003300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210398,728731,539975,493041,514296,654138,356085,890947,890207,574601,192722,441031,466914,16707,22538,680495,1036029,600446,267773,314242,618310,256470,785804,918534,318364,81151,401361,696598,655964,624789,1022283,111291,290171,848803,133628,503899,565564,33923,572761,277199,698806,981545,190596,627186,490735,853361,153825,632658,754254,715133,520088,778729,618940,420894,1018541,193900,117883,1014721,949571,40687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]