SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014308 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014308 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483221,219313,95777,210020,630070,430237,101049,935938,731175,599078,397011,844342,291908,428681,631674,785986,213066,240939,918437,343616,599885,71596,843295,143579,603360,687324,307736,1034120,366705,866114,170437,784637,553550,614649,218379,280615,1040860,93034,490830,714783,411863,891648,130845,261429,914934,933524,198234,608703,287724,103406,403800,112398,391736,720506,1033410,482073,486949,1006658,626717,306108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]