SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511603 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511603 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32987,499348,52335,560537,385392,709772,798086,923716,973560,153572,566596,336930,73609,907904,443735,84171,169193,944208,48094,960105,121332,809799,345125,931597,714355,565343,387233,532396,839787,883060,197927,1045897,9736,583329,571268,324760,356149,92678,1036071,482015,804956,608847,387,274045,375015,482209,917044,887727,429715,805417,543846,673556,395929,316201,307271,376923,400896,821576,631265,28239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]