SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335524 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335524 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829543,205458,809959,351228,461410,76076,1018487,625416,106953,124228,485880,780472,948037,834591,50677,361652,560237,205826,133310,38822,179432,388316,564759,452807,493706,447896,999742,402859,672837,335579,497497,395323,572123,336443,825518,763821,907449,511098,662248,463777,556084,248628,735766,954647,577103,158068,833430,214387,393714,834159,924910,585394,287209,265777,254260,852926,824952,353431,960549,25324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]