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` = 444473 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444473 [ RunTime:0.003798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377873,146662,1016114,622498,848578,74822,976674,318491,161756,433829,482024,567979,701823,937246,724963,63342,860438,1008232,101774,37726,432111,672159,296525,788195,680434,199856,135793,843329,791080,20973,148316,146419,59688,989453,515685,77359,673008,489940,490108,395808,1017773,888889,177298,384122,212564,95125,934093,470108,1019669,250832,254732,142818,453445,283120,515464,718218,587436,634393,35581,306130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001920s ]