SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516967 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516967 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313185,116547,292262,663674,451754,989199,1014642,188634,556086,650640,539066,1039331,561440,493855,173253,564444,95113,323652,404134,226431,623202,531098,896561,632429,476203,503499,138789,281136,140501,427886,957076,841647,977873,75274,708838,422406,455617,895012,121321,563986,722951,898451,441324,456958,369404,418151,140791,616490,1007151,469558,813158,495203,363803,665350,967058,715237,110613,609447,756204,856234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]