SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43383 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43383 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353470,52275,323752,269282,175236,457509,746189,933134,183516,453367,819167,226631,415439,697471,380878,254112,47111,363539,616539,798411,503674,445064,59030,23839,69587,86269,65638,306943,273354,621273,449769,330800,51134,569733,577305,967877,347500,482072,406406,979999,607812,687326,172259,95249,286880,737912,784838,223396,536513,212351,367932,311784,1009927,24108,945186,64341,1024375,517085,114046,489444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]