SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499474 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499474 [ RunTime:0.002263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64410,589917,612523,968026,501008,1023660,1016751,970390,620189,148424,123872,596304,236991,939775,245741,155829,78902,363159,743454,304991,29192,590592,1032714,124765,1004413,434237,818576,132949,1074,667801,158141,360617,48150,628625,483025,703173,548654,855646,470651,809876,1043393,326352,568558,202984,624501,516400,444734,658629,844563,619077,811859,648773,189315,916318,214412,933893,479414,836392,921104,829715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001143s ]