SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519042 LIMIT 1 [ RunTime:0.000716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519042 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712367,891718,776146,981845,1010891,937029,440748,300967,232994,205195,395205,424693,908651,813658,694851,311514,812311,770225,374464,872663,822591,100256,811304,858664,541821,435618,13761,982788,229308,712189,126316,338219,340960,543056,861517,985063,536615,57119,715780,153652,434609,504288,223216,47991,790360,287019,843266,129039,65238,199382,94085,291685,558373,153502,694316,560530,260267,263798,305539,814071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002599s ]