SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521116 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521116 [ RunTime:0.002207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246718,274959,765233,81995,790250,949226,967357,298800,390534,462955,384350,94895,562774,563063,52678,715736,756980,614896,324040,704550,965762,194931,253110,271866,226635,695652,594528,96876,449584,1034509,269156,406311,158400,85783,921320,587008,432941,575088,104391,523801,926,894088,871807,756874,956613,755338,330404,255301,340310,378217,212730,203277,1042033,33055,973753,584337,608381,207033,545153,9916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]