SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421781 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421781 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39587,951917,157986,618777,6793,206632,690196,973658,873213,705482,925341,334323,36041,124629,188309,105223,548144,654509,494867,743818,814084,339033,770086,1026490,953974,714353,137787,620336,648536,758076,558657,272383,441391,322018,953054,212023,292130,858621,1029886,939668,14340,596086,746110,825083,28792,453333,130963,150506,426734,695793,984553,64873,728836,804638,97640,880826,987134,73383,864967,882853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]