SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281891 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281891 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982317,828170,903665,74823,353778,893770,865067,613955,676243,411698,135576,22555,385493,885392,542251,503035,374149,155668,13096,435031,708829,601919,545106,505146,55492,144224,485847,403314,791336,676548,224542,391806,50274,843052,737082,584562,940790,795276,899531,460134,611800,503006,35049,359214,898428,117520,213600,970068,523067,653842,296215,1013587,43774,807893,172590,614685,1009020,775580,680055,953311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003721s ]