SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504473 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504473 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224367,679247,10371,441235,943654,21481,858318,909813,488043,711184,1016159,910795,113612,474638,809576,83621,265207,995710,805793,589226,1031090,993508,1014999,245639,970298,825422,275649,30179,798708,706327,22443,386218,642834,862553,958168,518029,213920,724292,1023968,391177,925972,189670,486101,965628,627748,398297,700893,1048155,640510,987989,565389,423710,1006732,119861,465512,462961,1020097,655126,976589,185792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001677s ]