SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45133 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45133 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189940,346336,513044,288765,1046919,777928,1012116,445604,48882,643004,991498,725055,402510,940797,763934,816998,796094,224501,554696,448239,166381,100478,350221,909479,1022703,243768,832545,920901,698870,290345,942773,16910,543242,820305,930830,385473,373814,716870,951285,88438,1010201,765318,48245,670231,591941,617542,83645,312018,239931,489209,71698,133780,979117,199142,43325,1043634,910927,711632,46278,43344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]