SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397513 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397513 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694398,976064,522164,451928,310478,106464,777194,22409,602116,669250,14706,758937,420794,918184,192662,877456,674706,84553,481917,1043587,632856,1043179,140822,108822,1034242,848000,866143,578422,963612,254775,976576,18817,890647,176815,479929,313750,273274,172255,606821,750292,197145,340538,714734,906470,374836,439971,502154,270258,657803,305962,1047522,333205,118260,832013,459625,154483,709885,29975,582355,377610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]