SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567628 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567628 [ RunTime:0.002735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322261,468446,118643,441656,484694,282468,52535,968207,759485,24376,398771,132900,765249,843184,291391,573123,995986,1013576,1024216,741998,856827,381885,337029,9044,869181,682236,786884,20046,232887,455951,269706,958797,605272,549136,654390,41889,522182,784866,598505,203326,23013,552991,324296,735117,354723,435229,533988,722502,48491,776900,201710,392931,694731,439055,27867,672133,213654,725833,128459,1017269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]