SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572016 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572016 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878169,793694,991586,49765,500025,852393,132529,628738,910435,966651,308728,614427,684577,137443,821928,149974,207901,578111,190394,891308,451581,811990,197465,603485,941928,769277,1029181,770434,735184,708180,930801,158656,883613,996422,76651,303992,756378,521737,33306,504657,477750,471786,800995,125548,989520,174081,608462,152111,904380,955027,84449,251,221955,511903,174144,186410,855332,281387,961537,872085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]